Computer Question Bank
for Exam preparation

Computer- Q2. Ms Access: Which of the following types of joins displays records with the same value in the common field?

1. Inner join
2. Left outer join
3. Right outer join
4. Self join

Computer- Q3. Ms Access: You can move between fields in a form by using any of these keys except

1. Tab
2. Enter
3. Shift+tab
4. Page up

Computer- Q4. What is the minimum header size of an IP packet?

1. 16 bytes
2. 10 bytes
3. 20 bytes
4. 32 bytes

Computer- Q5. Ms Access: Which of the following statement is true

1. Reports can be used to retrieve data from tables and calculate
2. Queries can be printed in well formatted manner and presented as the information
3. Queries can include calculated fields that do not exist in table
4. Reports and forms are similar but forms are use to print but reports to display on screen only

Computer- Q6. Ms Excel:Which function is not available in the Consolidate dialog box?

1. Pmt
2. Average
3. Max
4. Sum

Computer- Q7. Ms Excel:How do you display current date and time in MS Excel?

1. date ()
2. Today ()
3. now ()
4. time ()

Computer- Q8. Ms Excel:What does the NOW() function return?

1. It returns the serial number of the current date and time
2. It returns the serial number of the current date
3. It returns the serial number of the current time
4. None of the above

Computer- Q9. Which of the following memory is most volatile?

1. SRAM
2. DRAM
3. CMOS RAM
4. EEPROM

Computer- Q10. Ms Excel:How do you tell one cell from another?

1. By numbers
2. By letters
3. By its address
4. by color